My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
-
TOP CONTRIBUTOR FOR SEPTEMBER 2022!
Another fantastic month for one of our members who got 20 reactions, 6 Accepted Answers and participated in 24 discussions! Once again, congratulations to @Gaurav_NS for being September's Top Co…1 -
Re: Using % Formula of Summary level
Hi @Buckeye1497, Try this formula: {quantity}/NULLIF(TO_NUMBER({item.custitem_containerquantity}),0) When using this field in a formula/computation, you need to convert the value to a number first si…1 -
Re: TOP CONTRIBUTOR FOR AUGUST 2022!
WOW! 31 Reactions, 15 Accepted Answers & 33 discussions participated in! Congratulations, @Gaurav_NS! 👏1 -
Re: Custom Total Amounts on Saved Search
Hi @Tybrneryan, Glad to have you with us today! Try these formula: Sum of Positives: CASE WHEN {amount} > 0 THEN {amount} END Sum of Negatives: CASE WHEN {amount} < 0 THEN {amount} END Hope thi…1 -
Re: Saved Search | Show Built Qty and Used in Build Qty in Work Orders
Hi @GLL, The sample I showed is just a simple search with the Criteria Type = Work Order. The Results fields are: Document Number Item * (This represents Main Line) Quantity Quantity Fulfilled/Receiv…1
